package com.boss.salary.dao.impl;

import com.boss.framework.dao.BaseDaoImpl;
import com.boss.salary.constant.TableName;
import com.boss.salary.dao.IFileSendLogDao;
import org.springframework.stereotype.Repository;

@Repository
public class FileSendLogDaoImpl extends BaseDaoImpl implements IFileSendLogDao {

    @Override
    public int selectNoSendFileCount(String province) {
        StringBuilder sb = new StringBuilder();
        sb.append(" select count(*) from ")
                .append(TableName.FILE_SEND_LOG)
                .append(" where is_send = 0 and mof_div_code = ? ");
        return super.getjdbcTemplate().queryForObject(sb.toString(), int.class, province);
    }
}
